let server = require('express')();
let mysql = require('mysql');
let ejs = require('ejs');
const port = 81;


server.all("*",function(req,res,next){
    //设置允许跨域的域名，*代表允许任意域名跨域
    res.header("Access-Control-Allow-Origin","*");
    //允许的header类型
    res.header("Access-Control-Allow-Headers","content-type");
    //跨域允许的请求方式 
    res.header("Access-Control-Allow-Methods","DELETE,PUT,POST,GET,OPTIONS");
    if (req.method.toLowerCase() == 'options')
        res.send(200);  //让options尝试请求快速结束
    else
        next();
})

let sql = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : '123456',
    database : 'list'
});
   
  // 尝试链接
  sql.connect();

server.get("/listList",function(request,response){
    sql.query('select * from lists',function(error,data){
        if(error){
            console.log(error);
            response.end("error");
        }
        else{
            response.send(JSON.stringify(data))
        }
    })

})

let id = 0;
server.get("/click",function(request,response){
  id = request.query.id;
  server.get("/listListmore",function(request,response){
    sql.query(`SELECT * FROM listmore WHERE id=${id}`,function(error,data){
      if(error){
        console.log(error)
        response.send("error")
        return;
      }
      response.send(JSON.stringify(data));
    })
  })
})


server.get("/click2",function(request,response){
  id = request.query.id;
  server.get("/secionListmore",function(request,response){
    sql.query(`SELECT * FROM secionmore WHERE id=${id}`,function(error,data){
      if(error){
        console.log(error)
        response.send("error")
        return;
      }
      response.send(JSON.stringify(data));
    })
  })
})

server.get("/list2",function(request,response){
    ejs.renderFile("list2.html",{},(error,result)=>{
        if(error){
            console.log(error)
            response.end("error")
        }
        else{
            response.end(result)
        }
    })

})
server.get("/secion2",function(request,response){
    ejs.renderFile("secion2.html",{},(error,result)=>{
        if(error){
            console.log(error)
            response.end("error")
        }
        else{
            response.end(result)
        }
    })

})


server.get("/count", (request, response) => {
    let id = request.query.id
    sql.query(`SELECT * FROM listmore WHERE id="${id}"`, (error, data) => {
        if (error) {
            response.send("error")
            console.log(error)
        } else {
            response.send(data[0])
        }
    })
})


server.get("/secionlist",function(request,response){
    let id = request.query.id;
    sql.query('select * from secion',function(error,data){
        if(error){
            console.log(error);
            response.end("error");
        }
        else{
            response.send(JSON.stringify(data))
        }
    })

})


server.listen(port)
console.log("server is running at " + port)